USE [taobaogather]
GO
/****** Object:  Table [dbo].[UpdatedShop]    Script Date: 05/06/2011 10:34:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UpdatedShop](
	[Nick] [nvarchar](250) NOT NULL,
	[LastUpdatedDate] [datetime] NOT NULL,
	[LastUpdatedYear] [int] NOT NULL,
	[LastUpdatedWeekIndex] [int] NOT NULL,
	[UID] [nvarchar](150) NOT NULL,
	[Seller_Credit_Level] [bigint] NULL,
	[Seller_Credit_Score] [bigint] NULL,
	[Seller_Credit_TotalNum] [bigint] NULL,
	[Seller_Credit_GoodNum] [bigint] NULL,
	[Buyer_Credit_Level] [bigint] NULL,
	[Buyer_Credit_Score] [bigint] NULL,
	[Buyer_Credit_TotalNum] [bigint] NULL,
	[Buyer_Credit_GoodNum] [bigint] NULL,
	[Location_Zip] [nvarchar](50) NULL,
	[Location_Address] [nvarchar](300) NULL,
	[Location_City] [nvarchar](100) NULL,
	[Location_State] [nvarchar](100) NULL,
	[Location_Country] [nvarchar](50) NULL,
	[Location_District] [nvarchar](100) NULL,
 CONSTRAINT [PK_UpdatedShops] PRIMARY KEY CLUSTERED 
(
	[Nick] ASC
) 
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Shop]    Script Date: 05/06/2011 10:34:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Shop](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[AppKey] [nvarchar](255) NOT NULL,
	[AppSecret] [nvarchar](255) NOT NULL,
	[Name] [nvarchar](255) NULL,
	[Updated] [datetime] NULL,
	[Status] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_Shop] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
) 
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Item]    Script Date: 05/06/2011 10:34:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Item](
	[NumIId] [bigint] NOT NULL,
	[DetailUrl] [nvarchar](500) NULL,
	[Title] [nvarchar](500) NULL,
	[Nick] [nvarchar](150) NOT NULL,
	[Type] [nvarchar](150) NULL,
	[PropsName] [nvarchar](1500) NULL,
	[Created] [datetime] NULL,
	[PromotedService] [nvarchar](150) NULL,
	[Cid] [bigint] NULL,
	[SellerCids] [nvarchar](1000) NULL,
	[Props] [nvarchar](1000) NULL,
	[InputPids] [nvarchar](1000) NULL,
	[InputStr] [nvarchar](1500) NULL,
	[Desc] [ntext] NULL,
	[PicUrl] [nvarchar](250) NULL,
	[Num] [bigint] NULL,
	[ValidThru] [int] NULL,
	[ListTime] [datetime] NULL,
	[DelistTime] [datetime] NULL,
	[StuffStatus] [nvarchar](150) NULL,
	[Price] [float] NULL,
	[PostFee] [float] NULL,
	[ExpressFee] [float] NULL,
	[EMSFee] [float] NULL,
	[HasDiscount] [bit] NULL,
	[FreightPlayer] [nvarchar](150) NULL,
	[HasInvoice] [bit] NULL,
	[HasWarranty] [bit] NULL,
	[HasShowcase] [bit] NULL,
	[Modified] [datetime] NULL,
	[Increment] [nvarchar](150) NULL,
	[ApproveStatus] [nvarchar](150) NULL,
	[PostageId] [bigint] NULL,
	[ProductId] [bigint] NULL,
	[AuctionPoint] [bigint] NULL,
	[PropertyAlias] [nvarchar](500) NULL,
	[OuterId] [nvarchar](150) NULL,
	[IsVirtual] [bit] NULL,
	[IsTaobao] [bit] NULL,
	[IsEx] [bit] NULL,
	[IsTiming] [bit] NULL,
	[Is3D] [bit] NULL,
	[Score] [bigint] NULL,
	[Volume] [bigint] NULL,
	[OneStation] [bit] NULL,
	[SecondKill] [nvarchar](50) NULL,
	[AutoFill] [nvarchar](50) NULL,
	[Violation] [bit] NULL,
	[IsPrepay] [bit] NULL,
	[WWStatus] [bit] NULL,
	[WapDesc] [ntext] NULL,
	[WapDetailUrl] [nvarchar](500) NULL,
	[AfterSaleId] [bigint] NULL,
	[CodPostageId] [bigint] NULL,
	[SellPromise] [bit] NULL,
	[UpdateDate] [datetime] NOT NULL,
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[IId] [nvarchar](100) NULL,
	[LocationAddress] [nvarchar](100) NULL,
	[LocationCountry] [nvarchar](100) NULL,
	[LocationCity] [nvarchar](100) NULL,
	[LocationDistrict] [nvarchar](100) NULL,
	[LocationZip] [nvarchar](20) NULL,
	[LocationState] [nvarchar](100) NULL,
	[UpdateWeekIndex] [int] NOT NULL,
	[UpdateYear] [int] NOT NULL,
 CONSTRAINT [PK_Item] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
